A Map node in a SAS^® Campaign Studio diagram can return incorrect counts when there is an underlying left join in the information map.

For example, if you have a customer table (with a subject ID of customer) and an account table with a one-to-many relationship, the account table has two subject IDs: customer and account.

In order to allow a multi-select node to return customers who do not have accounts, when selecting customers and accounts, you need to make the relationship between the two tables a left join in the information map.

However, if at some stage you map from account to customer, the left join causes customers without accounts to be returned in addition to those with accounts, making the counts incorrect as the following SQL sample illustrates:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 5.1 is available at: